[dbo].[BAEEventSetupGetGroup]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEEventSetupGetGroup
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@eventCode
varchar(15)
15
@groupName
varchar(10)
10
SQL Script
create
procedure
[dbo]
.
[BAEEventSetupGetGroup]
@eventCode
varchar
(
15
),
@groupName
varchar
(
10
)
as
SELECT
*
FROM
EventSetupGroup
WHERE
EventCode
=
@eventCode
AND
GroupName
=
@groupName
GO
Uses
[dbo].[EventSetupGroup]
dbo